Table: Invoice Posting Cost Lines

Table: POINVT
View: PO0441
Record length: 792
Flags: A R 

Keys: 1

Title  Flags  Fields

Master Key   INVISEQ, INVHSEQ, INVSSEQ

Fields: 83

Field  Type  Title  Presentation 

INVISEQ  BCD*10.0  Invoice Sequence Key   
INVHSEQ  BCD*10.0  Invoice Sequence Key   
INVSSEQ  BCD*10.0  Invoice Cost Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
OPERATION  Integer  Operation To Post   
RCPHSEQ  BCD*10.0  Receipt Sequence Key   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence   
ADDCOST  String*6  Additional Cost  Mask: %-6N
DESCRIPTIO  String*60  Description   
GLEXPACCT  String*45  Expense Account  Mask: %-45C
GLRETACCT  String*45  Return Account  Mask: %-45C
AMOUNT  BCD*10.3  Amount   
PRORMETHOD  Integer  Proration Method  List: 5 entries
1=No Proration
2=Prorate by Quantity
3=Prorate by Cost
4=Prorate by Weight
5=Prorate Manually
REPRORATE  Integer  Reproration Method   
TAXICLASS1  Integer  Cost Tax Class 1   
TAXICLASS2  Integer  Cost Tax Class 2   
TAXICLASS3  Integer  Cost Tax Class 3   
TAXICLASS4  Integer  Cost Tax Class 4   
TAXICLASS5  Integer  Cost Tax Class 5   
TAXBASE1  BCD*10.3  Tax Base 1   
TAXBASE2  BCD*10.3  Tax Base 2   
TAXBASE3  BCD*10.3  Tax Base 3   
TAXBASE4  BCD*10.3  Tax Base 4   
TAXBASE5  BCD*10.3  Tax Base 5   
TAXINCLUD1  Boolean  Tax Includable 1  List: 2 entries
0=No
1=Yes
TAXINCLUD2  Boolean  Tax Includable 2  List: 2 entries
0=No
1=Yes
TAXINCLUD3  Boolean  Tax Includable 3  List: 2 entries
0=No
1=Yes
TAXINCLUD4  Boolean  Tax Includable 4  List: 2 entries
0=No
1=Yes
TAXINCLUD5  Boolean  Tax Includable 5  List: 2 entries
0=No
1=Yes
TXINCLUDE1  BCD*10.3  Included Tax Amount 1   
TXINCLUDE2  BCD*10.3  Included Tax Amount 2   
TXINCLUDE3  BCD*10.3  Included Tax Amount 3   
TXINCLUDE4  BCD*10.3  Included Tax Amount 4   
TXINCLUDE5  BCD*10.3  Included Tax Amount 5   
TXRECVAMT1  BCD*10.3  Tax Recoverable Amount 1   
TXRECVAMT2  BCD*10.3  Tax Recoverable Amount 2   
TXRECVAMT3  BCD*10.3  Tax Recoverable Amount 3   
TXRECVAMT4  BCD*10.3  Tax Recoverable Amount 4   
TXRECVAMT5  BCD*10.3  Tax Recoverable Amount 5   
TXEXPSAMT1  BCD*10.3  Tax Expense Amount 1   
TXEXPSAMT2  BCD*10.3  Tax Expense Amount 2   
TXEXPSAMT3  BCD*10.3  Tax Expense Amount 3   
TXEXPSAMT4  BCD*10.3  Tax Expense Amount 4   
TXEXPSAMT5  BCD*10.3  Tax Expense Amount 5   
TXALLOAMT1  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  BCD*10.3  Tax Allocated Amount 5   
TXBASEALLO  BCD*10.3  Net of Tax   
TFBASEALLO  BCD*10.3  (FC) Net of Tax   
TFINCLUDE1  BCD*10.3  (FC) Tax Included Amount 1   
TFINCLUDE2  BCD*10.3  (FC) Tax Included Amount 2   
TFINCLUDE3  BCD*10.3  (FC) Tax Included Amount 3   
TFINCLUDE4  BCD*10.3  (FC) Tax Included Amount 4   
TFINCLUDE5  BCD*10.3  (FC) Tax Included Amount 5   
TFALLOAMT1  BCD*10.3  (FC) Tax Allocated Amount 1   
TFALLOAMT2  BCD*10.3  (FC) Tax Allocated Amount 2   
TFALLOAMT3  BCD*10.3  (FC) Tax Allocated Amount 3   
TFALLOAMT4  BCD*10.3  (FC) Tax Allocated Amount 4   
TFALLOAMT5  BCD*10.3  (FC) Tax Allocated Amount 5   
TFRECVAMT1  BCD*10.3  (FC) Tax Recoverable Amount 1   
TFRECVAMT2  BCD*10.3  (FC) Tax Recoverable Amount 2   
TFRECVAMT3  BCD*10.3  (FC) Tax Recoverable Amount 3   
TFRECVAMT4  BCD*10.3  (FC) Tax Recoverable Amount 4   
TFRECVAMT5  BCD*10.3  (FC) Tax Recoverable Amount 5   
TFEXPSAMT1  BCD*10.3  (FC) Tax Expense Amount 1   
TFEXPSAMT2  BCD*10.3  (FC) Tax Expense Amount 2   
TFEXPSAMT3  BCD*10.3  (FC) Tax Expense Amount 3   
TFEXPSAMT4  BCD*10.3  (FC) Tax Expense Amount 4   
TFEXPSAMT5  BCD*10.3  (FC) Tax Expense Amount 5   
MTOPRORATE  BCD*10.3  Manual To Prorate   
RCPHSEQC  BCD*10.0  Receipt/Apply To Receipt Seq Key   
BILLRATE  BCD*10.6  Billing Rate   
RTGPERCENT  BCD*5.5  Retainage Percentage   
RTGDAYS  Integer  Retention Period   
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGDATEDUE  Date  Retainage Due Date   
RTGAMTOVER  Boolean  Retainage Amount Overridden   
RTGDDTOVER  Boolean  Retainage Due Date Overridden   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.